Home:ALL Converter>SSMA for Oracle "Connect to Oracle" error

SSMA for Oracle "Connect to Oracle" error

Ask Time:2017-07-10T16:07:43         Author:이미진

Json Formatter

i tried to connect to Oracle using Sql server migration assistant for oracle(SSMA for oracle). and specified parameters like this

provider: Oracle Client Provider

mode: standard mode

and connection info(servername, port ...)

but i got a error message

"Unable to find specified provider. Compatible Oracle Data Access Connectivity libraries were not found on the machine. You can install them from Oracle product media or download it from Oracle web site."

so i installed Oracle Data Access Components(ODAC), http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

but same error message appeared.

what is Compatible Oracle Data Access Connectivity library?

Author:이미진,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/45006803/ssma-for-oracle-connect-to-oracle-error
yy